package com.ruoyi.wx.mapper;

import com.ruoyi.wx.entity.PtScore;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 实验成绩表 Mapper 接口
 * </p>
 *
 * @author moxiu
 * @since 2022-03-04
 */
public interface PtScoreMapper extends BaseMapper<PtScore> {

    /**
     * 拿到就是拿到 艹
     * @param userId 学生id
     * @param expId 实验id
     * @return 观看集合集合
     */
    @Select("SELECT video_list FROM pt_score WHERE user_id = #{userId} AND exp_id = #{expId}")
    String selectVideoList(@Param("userId") Long userId, @Param("expId")Long expId);

}
